Introduction

For our project, our domain of interest is to observe the transition of standardized tests being a requirement for admission by universities. Specifically, we have narrowed our scope to analyze the relationship between average SAT scores and their relationship to income across cities in California. As an objective of our project, we would like to uncover some of the discepencies from area to area and how it affects students’ score. Thus, findings from our report will reveal whether standardized test are a true reflection of a student’s capabilities. The source of the data is from California Department Of Education and IRS website.

Purpose of the Project

Summary Information

The summary includes some interesting analysis of how household income corelates to a student’s total SAT score. Based on our data, the mean and median household income for California is 62717 and 56646 respectively.The average SAT score for kids in below average income household was 1364.5 and for kids in above average income household was 1539.3.The zip code with the highest median household income was 95070.

Summary Table

The summary table portrays how total sat score and mean household income are different for different areas(Zip code) in California.

From the table, we can clearly observe that zip codes in the beggining of the list are the areas with way less than average household income and low sat scores whereas zip codes towards the end of the list are the areas with way more average household incomes and higher sat scores.

First Visualization

The purpose of this visualization is to highlight the potential relationship between geographical locations and the average SAT performace. Using map visualization, we can get a better insight on location vs. SAT performance. Here is the visualization:

From the map visualization we can see there seems to be a higher percentage of student passing the performance benchmark near San Francisco and Sacramento than other places. Student near Fresno seems to have lower performance than others.

Second Visualization

## 
## Attaching package: 'plotly'
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## The following object is masked from 'package:stats':
## 
##     filter
## The following object is masked from 'package:graphics':
## 
##     layout

Third Visualization